单据设置
概述
单据类型
** New **单据类型
select b.ad_reference_id, b.name as ad_reference_name, a.name as ad_ref_list_name , c.name
from ad_ref_list a
join ad_reference b on a.ad_reference_id=b.ad_reference_id
join ad_ref_list_trl c on a.ad_ref_list_id = c.ad_ref_list_id
where b.name ~'DocBaseType'
order by 3
SELECT AD_Table_ID, TableName
FROM AD_Table t
WHERE EXISTS
(SELECT * FROM AD_Column c
WHERE t.isview='N' AND t.AD_Table_ID=c.AD_Table_ID AND c.IsActive='Y'
AND c.ColumnName='Posted');